<?php
// 简单的数据库查询脚本
require_once 'application/common.php';

use think\Db;

try {
    $data = Db::name('scanwork_employee_performance')
        ->field('id,employee_id,stat_date,quality_rate,efficiency_rate,performance_score')
        ->select();
    
    echo "员工绩效数据:\n";
    foreach($data as $row) {
        echo "ID: {$row['id']}, Employee: {$row['employee_id']}, Date: {$row['stat_date']}, Quality: {$row['quality_rate']}, Efficiency: {$row['efficiency_rate']}, Score: {$row['performance_score']}\n";
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}
?>
